OpenEdge Getting Started:<br />New and Revised Features DataServers

Release 10.1A includes the following enhancements in support of DataServer MS SQL Server ORACLE DataServers’ stored procedures functionality:

Use of the LOAD-RESULT-INTO function.

Defined as part of the RUN STORED-PROCEDURE statement, the LOAD-REULT-INTO phrase enables an RDBMS stored procedure or send-sql-statement to be executed against a foreign data source for which the result sets that are derived can be loaded directly into one or more Progress static and/or dynamic temp-tables. The data in temp-tables can then be manipulated, employing all capabilities inherent to temp-tables.

Depending on the type of temp-table you choose to populate using the LOAD-RESULT-INTO phrase, preliminary data setup tasks might be required. For example, result sets returned to a static or dynamic-prepared temp-table require you to define the layout of the result set data. In contrast, you do not have to perform any data setup tasks for a dynamic-unprepared temp-table; the temp-table’s schema is based on the result-set schema and a mapping of default Progress data types for each SQL type.

As an enhancement to current stored procedure techniques, the use of the LOAD-RESULT-INTO phrase enables you to extend your code in new ways to more effectively employ more Progress 4GL features and functionality.

Support for ROWID functionality

Made possible through the use of the optional LOAD-RESULT-INTO function in the RUN STORED-PROCEDURE statement, Release 10.1A supports a new adaptation of ROWID functionality, which in turn supports an alternative means to populate temp-tables of a ProDataSet Object.

The purpose and default behavior of the ROWID function has not changed. That is, the ROWID continues to represent a unique key in a database even through it is not stored directly in the MS SQL data source. However, when used in the context of mapping a temp-table ROWID to a dataserver record identifier facilitated by the use of LOAD-RESULT-INTO, these values can be interpreted from one to the other (for example, from record id to ROWID.) The ROWID is stored along side its corresponding result rows within the temp-table.

For detailed syntax updates to the RUN STORED-PROCEDURE statement, example usages of the LOAD-RESULT-INTO phrase and ROWID function, and more information about this functionality, see: